CREATE TABLE [dbo].[tb_TiposDeAcumuladores]
(
[idTipoIndice] [int] NOT NULL IDENTITY(1, 1),
[Descripcion] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ParametroTemporal] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UnidadTiempo] [int] NULL,
[RequiereParametro] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TablaParametro] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CampoParametro] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TipoCampoParametro] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[StoreProcedure] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Reporte] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[tb_TiposDeAcumuladores] ADD CONSTRAINT [PK_tb_TiposDeAcumuladores] PRIMARY KEY NONCLUSTERED  ([idTipoIndice]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[tb_TiposDeAcumuladores] WITH NOCHECK ADD CONSTRAINT [FK_tb_TiposDeAcumuladores_tb_UnidadDeTiempo] FOREIGN KEY ([UnidadTiempo]) REFERENCES [dbo].[tb_UnidadDeTiempo] ([idUnidad])
GO
